package com.icinfo.cloud.provider.punish.common.publicsecurityentrust.mapper;

import com.icinfo.cloud.provider.punish.common.publicsecurityentrust.dto.PublicSecurityDocumentNumberPageDTO;
import com.icinfo.cloud.provider.punish.common.publicsecurityentrust.model.CasePublicSecurityEntrustDocumentNumber;
import com.icinfo.cloud.provider.punish.common.publicsecurityentrust.vo.PublicSecurityMaxAndMinDocumentNumberVo;
import com.icinfo.framework.mybatis.mapper.common.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author HKxxx
* @description 针对表【case_public_security_entrust_document_number(公安委托执法-文书号段信息)】的数据库操作Mapper
* @createDate 2023-12-29 10:01:27
* @Entity generator.domain.CasePublicSecurityEntrustDocumentNumber
*/
public interface CasePublicSecurityEntrustDocumentNumberMapper extends Mapper<CasePublicSecurityEntrustDocumentNumber> {





    List<CasePublicSecurityEntrustDocumentNumber> pageList(PublicSecurityDocumentNumberPageDTO queryDTO);

    /**
     * 得到部门编码下面未使用完的文号列表
     */
    List<CasePublicSecurityEntrustDocumentNumber> getResidualDocumentNumber(@Param("orgCode")String orgCode);

    /**
     * 查询部门最大号段最小号段
     *
     * @param orgCode 部门编码
     * @return
     */
    PublicSecurityMaxAndMinDocumentNumberVo selectOrgMaxAndMinNumber(@Param("orgCode") String orgCode);
}




